0

Phonepe_Project_final_VSL.ipynb

  1. Basic Python Script to Connect and Analyze
  2. Top 10 States by Total Transactions
Skip to Main
Jupyter

Phonepe_Project_final_VSL

Last Checkpoint: 17 minutes ago
  • File
  • Edit
  • View
  • Run
  • Kernel
  • Settings
  • Help
JupyterLab
Python [conda env:anaconda3] *
Kernel status: Idle
image/svg+xml
    [9]:
    import pandas as pd
    import mysql.connector
    import matplotlib.pyplot as plt
    import seaborn as sns

    %matplotlib
    Using matplotlib backend: module://matplotlib_inline.backend_inline
    
    ### Basic Python Script to Connect and Analyze

    Basic Python Script to Connect and Analyze¶

    [3]:
    # ✅ MySQL connection
    conn = mysql.connector.connect(
    host="localhost",
    user="root",
    password="Root",
    database="phonepe"
    )

    # ✅ SQL Query
    query = """
    SELECT year, SUM(transaction_amount) AS total_amount
    FROM aggregated_transaction
    GROUP BY year
    ORDER BY year;
    """

    df = pd.read_sql(query, conn)
    conn.close()

    # ✅ Plot
    plt.figure(figsize=(8,5))
    plt.plot(df['year'], df['total_amount'], marker='o', color='purple')
    plt.title("💰 Total Transactions Per Year")
    plt.xlabel("Year")
    plt.ylabel("Total Amount (₹)")
    plt.grid(True)
    plt.tight_layout()
    plt.show()

    C:\Users\LENOVO\AppData\Local\Temp\ipykernel_4080\3934802578.py:17: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.
      df = pd.read_sql(query, conn)
    C:\Users\LENOVO\AppData\Local\Temp\ipykernel_4080\3934802578.py:27: UserWarning: Glyph 128176 (\N{MONEY BAG}) missing from font(s) DejaVu Sans.
      plt.tight_layout()
    C:\Users\LENOVO\anaconda3\Lib\site-packages\IPython\core\pylabtools.py:170: UserWarning: Glyph 128176 (\N{MONEY BAG}) missing from font(s) DejaVu Sans.
      fig.canvas.print_figure(bytes_io, **kw)
    
    ### Top 10 States by Total Transactions

    Top 10 States by Total Transactions¶

    [11]:
    query = """
    SELECT state, SUM(transaction_amount) AS total_amount
    FROM aggregated_transaction
    GROUP BY state
    ORDER BY total_amount DESC
    LIMIT 10;
    """

    df = pd.read_sql(query, conn)

    # Plot
    plt.figure(figsize=(10,6))
    plt.barh(df['state'], df['total_amount'], color='skyblue')
    plt.gca().invert_yaxis() # Highest on top
    plt.title("🏆 Top 10 States by Total Transaction Amount")
    plt.xlabel("Amount (₹)")
    plt.tight_layout()
    plt.show()
    C:\Users\LENOVO\AppData\Local\Temp\ipykernel_4080\2086232993.py:9: UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.
      df = pd.read_sql(query, conn)
    
    ---------------------------------------------------------------------------
    OperationalError                          Traceback (most recent call last)
    Cell In[11], line 9
          1 query = """
          2 SELECT state, SUM(transaction_amount) AS total_amount
          3 FROM aggregated_transaction
       (...)
          6 LIMIT 10;
          7 """
    ----> 9 df = pd.read_sql(query, conn)
         11 # Plot
         12 plt.figure(figsize=(10,6))
    
    File ~\anaconda3\Lib\site-packages\pandas\io\sql.py:706, in read_sql(sql, con, index_col, coerce_float, params, parse_dates, columns, chunksize, dtype_backend, dtype)
        704 with pandasSQL_builder(con) as pandas_sql:
        705     if isinstance(pandas_sql, SQLiteDatabase):
    --> 706         return pandas_sql.read_query(
        707             sql,
        708             index_col=index_col,
        709             params=params,
        710             coerce_float=coerce_float,
        711             parse_dates=parse_dates,
        712             chunksize=chunksize,
        713             dtype_backend=dtype_backend,
        714             dtype=dtype,
        715         )
        717     try:
        718         _is_table_name = pandas_sql.has_table(sql)
    
    File ~\anaconda3\Lib\site-packages\pandas\io\sql.py:2738, in SQLiteDatabase.read_query(self, sql, index_col, coerce_float, parse_dates, params, chunksize, dtype, dtype_backend)
       2727 def read_query(
       2728     self,
       2729     sql,
       (...)
       2736     dtype_backend: DtypeBackend | Literal["numpy"] = "numpy",
       2737 ) -> DataFrame | Iterator[DataFrame]:
    -> 2738     cursor = self.execute(sql, params)
       2739     columns = [col_desc[0] for col_desc in cursor.description]
       2741     if chunksize is not None:
    
    File ~\anaconda3\Lib\site-packages\pandas\io\sql.py:2672, in SQLiteDatabase.execute(self, sql, params)
       2670     raise TypeError("Query must be a string unless using sqlalchemy.")
       2671 args = [] if params is None else [params]
    -> 2672 cur = self.con.cursor()
       2673 try:
       2674     cur.execute(sql, *args)
    
    File ~\anaconda3\Lib\site-packages\mysql\connector\connection_cext.py:841, in CMySQLConnection.cursor(self, buffered, raw, prepared, cursor_class, dictionary, read_timeout, write_timeout)
        839 self.handle_unread_result(prepared)
        840 if not self.is_connected():
    --> 841     raise OperationalError("MySQL Connection not available.")
        842 if read_timeout or write_timeout:
        843     warnings.warn(
        844         """The use of read_timeout after the connection has been established is unsupported
        845         in the C-Extension""",
        846         category=Warning,
        847     )
    
    OperationalError: MySQL Connection not available.
    [ ]:

    Notebook cell shifted up successfully

    -

    Variables

    Callstack

      Breakpoints

      Source

      9
      1

      Kernel Sources

      Common Tools
      No metadata.
      Advanced Tools
      No metadata.
      Anaconda Assistant
      4.1.0

      What would you like to do?

      The Anaconda Assistant is an AI-powered chat application designed to enhance the productivity of data scientists, developers, and researchers.

      Get started

      Working with dataframes

      Anaconda Assistant
      By debugging the active code cell, the error tied to the active code cell, and the code of the active code cell will be sent to OpenAI.
      Start a new conversation
      ​
      Select context
      Chat
      0%
      full
      Alt+[
      Alt+]
      Alt+End
      • Assistant
      • Open Anaconda Assistant
        Ctrl+Shift+A
      • Console
      • Change Kernel…
      • Clear Console Cells
      • Close and Shut Down…
      • Insert Line Break
      • Interrupt Kernel
      • New Console
      • Restart Kernel…
      • Run Cell (forced)
      • Run Cell (unforced)
      • Show All Kernel Activity
      • Debugger
      • Breakpoints on exception
      • Evaluate Code
        Evaluate Code
      • Next
        Next
        F10
      • Pause
        Pause
        F9
      • Step In
        Step In
        F11
      • Step Out
        Step Out
        Shift+F11
      • Terminate
        Terminate
        Shift+F9
      • Display Languages
      • English
        English
      • File Operations
      • Autosave Documents
      • Download
        Download the file to your computer
      • Reload Notebook from Disk
        Reload contents from disk
      • Revert Notebook to Checkpoint…
        Revert contents to previous checkpoint
      • Save Notebook
        Save and create checkpoint
        Ctrl+S
      • Save Notebook As…
        Save with new path
        Ctrl+Shift+S
      • Trust HTML File
        Whether the HTML file is trusted. Trusting the file allows scripts to run in it, which may result in security risks. Only enable for files you trust.
      • Help
      • About Jupyter Notebook
      • Jupyter Reference
      • JupyterLab FAQ
      • JupyterLab Reference
      • Launch Jupyter Notebook File Browser
      • Markdown Reference
      • Show Keyboard Shortcuts…
        Show relevant keyboard shortcuts for the current active widget
        Ctrl+Shift+H
      • Image Viewer
      • Flip image horizontally
        H
      • Flip image vertically
        V
      • Invert Colors
        I
      • Reset Image
        0
      • Rotate Clockwise
        ]
      • Rotate Counterclockwise
        [
      • Zoom In
        =
      • Zoom Out
        -
      • Kernel Operations
      • Shut Down All Kernels…
      • Main Area
      • Close All Other Tabs
      • Close Tab
        Alt+W
      • Close Tabs to Right
      • End Search
        Esc
      • Find Next
        Ctrl+G
      • Find Previous
        Ctrl+Shift+G
      • Find…
        Ctrl+F
      • Log Out
        Log out of Jupyter Notebook
      • Search in Selection
        Alt+L
      • Shut Down
        Shut down Jupyter Notebook
      • Mode
      • Toggle Zen Mode
      • Notebook Cell Operations
      • Change to Code Cell Type
        Y
      • Change to Heading 1
        1
      • Change to Heading 2
        2
      • Change to Heading 3
        3
      • Change to Heading 4
        4
      • Change to Heading 5
        5
      • Change to Heading 6
        6
      • Change to Markdown Cell Type
        M
      • Change to Raw Cell Type
        R
      • Clear Cell Output
        Clear outputs for the selected cells
      • Collapse All Code
      • Collapse All Outputs
      • Collapse Selected Code
      • Collapse Selected Outputs
      • Copy Cell
        Copy this cell
        C
      • Cut Cell
        Cut this cell
        X
      • Delete Cell
        Delete this cell
        D, D
      • Disable Scrolling for Outputs
      • Enable Scrolling for Outputs
      • Expand All Code
      • Expand All Outputs
      • Expand Selected Code
      • Expand Selected Outputs
      • Extend Selection Above
        Shift+K
      • Extend Selection Below
        Shift+J
      • Extend Selection to Bottom
        Shift+End
      • Extend Selection to Top
        Shift+Home
      • Insert Cell Above
        Insert a cell above
        A
      • Insert Cell Below
        Insert a cell below
        B
      • Insert Heading Above Current Heading
        Shift+A
      • Insert Heading Below Current Heading
        Shift+B
      • Merge Cell Above
        Ctrl+Backspace
      • Merge Cell Below
        Ctrl+Shift+M
      • Merge Selected Cells
        Shift+M
      • Move Cell Down
        Move this cell down
        Ctrl+Shift+Down
      • Move Cell Up
        Move this cell up
        Ctrl+Shift+Up
      • Paste Cell Above
        Paste this cell from the clipboard
      • Paste Cell and Replace
      • Paste Cell Below
        Paste this cell from the clipboard
        V
      • Redo Cell Operation
        Shift+Z
      • Render Side-by-Side
        Shift+R
      • Run Selected Cell
        Run this cell and advance
        Shift+Enter
      • Run Selected Cell and Do not Advance
        Ctrl+Enter
      • Run Selected Cell and Insert Below
        Alt+Enter
      • Run Selected Text or Current Line in Console
      • Select Cell Above
        K
      • Select Cell Below
        J
      • Select Heading Above or Collapse Heading
        Left
      • Select Heading Below or Expand Heading
        Right
      • Set side-by-side ratio
      • Split Cell
        Ctrl+Shift+-
      • Undo Cell Operation
        Z
      • Notebook Operations
      • Access Next Kernel History Entry
        Alt+Down
      • Access Previous Kernel History Entry
        Alt+Up
      • Change Kernel…
      • Clear Outputs of All Cells
        Clear all outputs of all cells
      • Close and Shut Down Notebook…
      • Collapse All Headings
        Ctrl+Shift+Left
      • Deselect All Cells
      • Edit Notebook Metadata
      • Enter Command Mode
        Ctrl+M
      • Enter Edit Mode
        Enter
      • Expand All Headings
        Ctrl+Shift+Right
      • Interrupt Kernel
        Interrupt the kernel
      • New Console for Notebook
      • New Notebook
        Create a new notebook
      • Open with Panel in New Browser Tab
      • Preview Notebook with Panel
      • Reconnect to Kernel
      • Render All Markdown Cells
      • Restart Kernel and Clear Outputs of All Cells…
        Restart the kernel and clear all outputs of all cells
      • Restart Kernel and Debug…
        Restart Kernel and Debug…
      • Restart Kernel and Run All Cells…
        Restart the kernel and run all cells
      • Restart Kernel and Run up to Selected Cell…
      • Restart Kernel…
        Restart the kernel
      • Run All Above Selected Cell
      • Run All Cells
        Run all cells
      • Run Selected Cell and All Below
      • Save and Export Notebook: Asciidoc
      • Save and Export Notebook: Executable Script
      • Save and Export Notebook: HTML
      • Save and Export Notebook: LaTeX
      • Save and Export Notebook: Markdown
      • Save and Export Notebook: PDF
      • Save and Export Notebook: Qtpdf
      • Save and Export Notebook: Qtpng
      • Save and Export Notebook: ReStructured Text
      • Save and Export Notebook: Reveal.js Slides
      • Save and Export Notebook: Webpdf
      • Select All Cells
        Ctrl+A
      • Show Line Numbers
      • Toggle Collapse Notebook Heading
      • Trust Notebook
      • Other
      • Open in JupyterLab
        JupyterLab
      • Plugin Manager
      • Advanced Plugin Manager
      • Terminal
      • Decrease Terminal Font Size
      • Increase Terminal Font Size
      • New Terminal
        Start a new terminal session
      • Refresh Terminal
        Refresh the current terminal session
      • Use Terminal Theme: Dark
        Set the terminal theme
      • Use Terminal Theme: Inherit
        Set the terminal theme
      • Use Terminal Theme: Light
        Set the terminal theme
      • Text Editor
      • Decrease Font Size
      • Increase Font Size
      • New Markdown File
        Create a new markdown file
      • New Python File
        Create a new Python file
      • New Text File
        Create a new text file
      • Spaces: 1
      • Spaces: 2
      • Spaces: 4
      • Spaces: 4
      • Spaces: 8
      • Theme
      • Decrease Code Font Size
      • Decrease Content Font Size
      • Decrease UI Font Size
      • Increase Code Font Size
      • Increase Content Font Size
      • Increase UI Font Size
      • Set Preferred Dark Theme: JupyterLab Dark
      • Set Preferred Dark Theme: JupyterLab Dark High Contrast
      • Set Preferred Dark Theme: JupyterLab Light
      • Set Preferred Light Theme: JupyterLab Dark
      • Set Preferred Light Theme: JupyterLab Dark High Contrast
      • Set Preferred Light Theme: JupyterLab Light
      • Synchronize Styling Theme with System Settings
      • Theme Scrollbars
      • Use Theme: JupyterLab Dark
      • Use Theme: JupyterLab Dark High Contrast
      • Use Theme: JupyterLab Light
      • View
      • File Browser
      • Open JupyterLab
      • Show Anaconda Assistant
        Show Show Anaconda Assistant in the right sidebar
      • Show Debugger
        Show Show Debugger in the right sidebar
      • Show Header
      • Show Notebook Tools
        Show Show Notebook Tools in the right sidebar
      • Show Table of Contents
        Show Show Table of Contents in the left sidebar